CREATE VIEW [dbo].[vSoaGroupMemberSummarySubscription]
WITH SCHEMABINDING
AS
    SELECT  CAST([p].[PRODUCT_CODE] + ':' + [s].[ID] AS VARCHAR(50)) AS [GroupMemberId],
            CAST([p].[PRODUCT_CODE] AS VARCHAR(50)) AS [GroupId],
            [s].[ID] AS [PartyId],
            CAST(NULL AS VARCHAR(70)) AS [PartyName],
            [s].[PAID_THRU],
            [s].[BEGIN_DATE],
            [s].[BEGIN_DATE] AS [JoinDate],
            [s].[PAID_THRU] AS [DropDate]
      FROM  [dbo].[Subscriptions] AS [s]
            INNER JOIN [dbo].[Product] AS [p] ON [s].[PRODUCT_CODE] = [p].[PRODUCT_CODE]
     WHERE  ( [p].[PROD_TYPE] IN ( 'DUES', 'SUB', 'SEC', 'CHAPT', 'VOL',
                                   'MISC' ) )


GO
CREATE UNIQUE CLUSTERED INDEX [PK_vSoaGroupMemberSummarySubscription] ON [dbo].[vSoaGroupMemberSummarySubscription] ([GroupMemberId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberSummarySubscription_GroupId] ON [dbo].[vSoaGroupMemberSummarySubscription] ([GroupId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_vSoaGroupMemberSummarySubscription_PartyId] ON [dbo].[vSoaGroupMemberSummarySubscription] ([PartyId]) ON [PRIMARY]
GO